const mysql = require('mysql')
const con = mysql.createConnection({
  host: '192.168.43.50',
  port:'8001',
  user: 'root',
  password: '123456',
  database: 'shiting'
})

con.connect();
const sql = 'SELECT * FROM `user`';
con.query(sql, function (error, results) {
  if (error){//throw error;
    console.log(error.message);
    return
  }
  console.log('--------------------------SELECT----------------------------');
  console.log('The solution is: ', results);
});